MySQL Query Optimization and Performance Tuning

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.

Download MySQL Query Optimization and Performance Tuning Introduction 00:01:59
Introduction 01:59
Optimizing Data Access 00:12:28
Introduction 01:10
Prerequisite 00:55
Overheard 01:15
Understanding Data Needs 02:03
Demo: Setup 00:33
Demo: Best Practices for Data Access 02:15
Demo: Why SELECT Star (*) is Bad Idea 03:53
Summary in Sixty Seconds 00:24
Download MySQL Query Optimization and Performance Tuning Understanding MySQL Query Optimization 00:26:07
Introduction 00:57
Execution Path of a Query 00:36
Client Protocols 02:15
Query Cache 01:04
Parser 00:47
Preprocessor 00:39
Query Optimizer 01:29
Query Optimizer Responsibilities 01:31
Query Optimizer Limitations 02:29
Query Execution Engine and Storage 01:31
Returning Result to Client 00:53
Additional Notes on Query Optimizer 00:55
Maximizing Query Optimizer Performance 00:40
Understanding Query States 02:02
Demo: Show Full Processlist 02:03
Understanding Explain Command 00:37
Demo: Explain Command 03:24
Demo: Explain Extended Command 01:49
Summary in Sixty Seconds 00:26
Download MySQL Query Optimization and Performance Tuning Performance Optimization by Practical Query Tuning 01:06:22
Introduction 01:35
Demo: Index Used for SELECT clause 08:02
Demo: One Complex Query vs Multiple Simple Queries 04:15
Demo: One Complex Query vs Multiple Simple Queries - Part 2 04:20
Demo: One Complex Query vs Multiple Simple Queries with Index 05:47
Demo: Table Order in Join Clause - INNER JOIN 05:53
Demo: Table Order in Join Clause - OUTER JOIN 03:31
Demo: Most Optimal Choice - Subquery vs Exists vs Joins 08:49
Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2 03:50
Demo: Tuning Aggregate Function 05:03
Demo: Optimizing Group By Clause 05:45
Demo: Optimizing Paging with LIMIT Clause 02:43
Demo: Impact on Performance of UNION and UNION ALL 03:55
Demo: Index and Not Equal to Operator 02:18
Summary in Sixty Seconds 00:36
Download MySQL Query Optimization and Performance Tuning Best Practices 00:03:50
Best Practices 03:50

Introduction	00:01:59
Introduction	01:59
Optimizing Data Access	00:12:28
Introduction	01:10
Prerequisite	00:55
Overheard	01:15
Understanding Data Needs	02:03
Demo: Setup	00:33
Demo: Best Practices for Data Access	02:15
Demo: Why SELECT Star (*) is Bad Idea	03:53
Summary in Sixty Seconds	00:24
Understanding MySQL Query Optimization	00:26:07
Introduction	00:57
Execution Path of a Query	00:36
Client Protocols	02:15
Query Cache	01:04
Parser	00:47
Preprocessor	00:39
Query Optimizer	01:29
Query Optimizer Responsibilities	01:31
Query Optimizer Limitations	02:29
Query Execution Engine and Storage	01:31
Returning Result to Client	00:53
Additional Notes on Query Optimizer	00:55
Maximizing Query Optimizer Performance	00:40
Understanding Query States	02:02
Demo: Show Full Processlist	02:03
Understanding Explain Command	00:37
Demo: Explain Command	03:24
Demo: Explain Extended Command	01:49
Summary in Sixty Seconds	00:26
Performance Optimization by Practical Query Tuning	01:06:22
Introduction	01:35
Demo: Index Used for SELECT clause	08:02
Demo: One Complex Query vs Multiple Simple Queries	04:15
Demo: One Complex Query vs Multiple Simple Queries - Part 2	04:20
Demo: One Complex Query vs Multiple Simple Queries with Index	05:47
Demo: Table Order in Join Clause - INNER JOIN	05:53
Demo: Table Order in Join Clause - OUTER JOIN	03:31
Demo: Most Optimal Choice - Subquery vs Exists vs Joins	08:49
Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2	03:50
Demo: Tuning Aggregate Function	05:03
Demo: Optimizing Group By Clause	05:45
Demo: Optimizing Paging with LIMIT Clause	02:43
Demo: Impact on Performance of UNION and UNION ALL	03:55
Demo: Index and Not Equal to Operator	02:18
Summary in Sixty Seconds	00:36
Best Practices	00:03:50
Best Practices	03:50